﻿CREATE PROCEDURE [acms].[User_GetByEmailAddress]
	@EmailAddress varchar(100),
	@SiteId int
AS
	SELECT *
	From User_View
	Where EmailAddress = @EmailAddress
		and isNull(SiteId, @SiteId) = @SiteId
	
RETURN 0;